// Licensed to the Apache Software Foundation (ASF) under one
// or more contributor license agreements.  See the NOTICE file
// distributed with this work for additional information
// regarding copyright ownership.  The ASF licenses this file
// to you under the Apache License, Version 2.0 (the
// "License"); you may not use this file except in compliance
// with the License.  You may obtain a copy of the License at
//
//   http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing,
// software distributed under the License is distributed on an
// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
// KIND, either express or implied.  See the License for the
// specific language governing permissions and limitations
// under the License.

suite("test_colocate_join_with_different_tablets") {
    sql """
    DROP TABLE IF EXISTS `USR_V_KHZHSJ_ES_POC1`;
    DROP TABLE IF EXISTS `USR_TLBL_VAL_R1`;
        CREATE TABLE `USR_V_KHZHSJ_ES_POC1` (
          `khid` bigint NULL,
          `khh` bigint NULL
        ) ENGINE=OLAP
        DUPLICATE KEY(`khid`, `khh`)
        DISTRIBUTED BY HASH(`khid`) BUCKETS 16
        PROPERTIES (
        "colocate_with" = "test_colocate_join_with_different_tabletsgroup1",
        "replication_allocation" = "tag.location.default: 1"
        );


        CREATE TABLE `USR_TLBL_VAL_R1` (
          `lbl_id` bigint NOT NULL COMMENT "标签ID",
          `khh` bigint NULL COMMENT "客户号"
        ) ENGINE=OLAP
        DUPLICATE KEY(`lbl_id`, `khh`)
        COMMENT '标签结果日表'
        PARTITION BY LIST (`lbl_id`)
        (PARTITION p0 VALUES IN ("0"),
        PARTITION p1 VALUES IN ("1"),
        PARTITION p29 VALUES IN ("29"),
        PARTITION p35 VALUES IN ("35"),
        PARTITION p57 VALUES IN ("57"),
        PARTITION p352 VALUES IN ("352"),
        PARTITION p402 VALUES IN ("402"),
        PARTITION p523 VALUES IN ("523"),
        PARTITION p2347 VALUES IN ("2347"),
        PARTITION p10376 VALUES IN ("10376"),
        PARTITION p42408 VALUES IN ("42408"),
        PARTITION p44410 VALUES IN ("44410"),
        PARTITION p48414 VALUES IN ("48414"),
        PARTITION p50416 VALUES IN ("50416"),
        PARTITION p52418 VALUES IN ("52418"),
        PARTITION p56422 VALUES IN ("56422"),
        PARTITION p60426 VALUES IN ("60426"),
        PARTITION p64430 VALUES IN ("64430"),
        PARTITION p66432 VALUES IN ("66432"),
        PARTITION p70436 VALUES IN ("70436"),
        PARTITION p72438 VALUES IN ("72438"),
        PARTITION p74440 VALUES IN ("74440"),
        PARTITION p78444 VALUES IN ("78444"),
        PARTITION p84450 VALUES IN ("84450"),
        PARTITION p86452 VALUES IN ("86452"),
        PARTITION p88454 VALUES IN ("88454"),
        PARTITION p90456 VALUES IN ("90456"),
        PARTITION p92458 VALUES IN ("92458"),
        PARTITION p94460 VALUES IN ("94460"),
        PARTITION p96462 VALUES IN ("96462"),
        PARTITION p98464 VALUES IN ("98464"),
        PARTITION p100466 VALUES IN ("100466"),
        PARTITION p102468 VALUES IN ("102468"),
        PARTITION p104470 VALUES IN ("104470"),
        PARTITION p106472 VALUES IN ("106472"),
        PARTITION p108474 VALUES IN ("108474"),
        PARTITION p110476 VALUES IN ("110476"),
        PARTITION p112478 VALUES IN ("112478"),
        PARTITION p114480 VALUES IN ("114480"),
        PARTITION p122488 VALUES IN ("122488"),
        PARTITION p124490 VALUES IN ("124490"),
        PARTITION p126492 VALUES IN ("126492"),
        PARTITION p130496 VALUES IN ("130496"),
        PARTITION p134500 VALUES IN ("134500"),
        PARTITION p150516 VALUES IN ("150516"),
        PARTITION p154520 VALUES IN ("154520"),
        PARTITION p158524 VALUES IN ("158524"),
        PARTITION p158525 VALUES IN ("158525"),
        PARTITION p1848141 VALUES IN ("1848141"),
        PARTITION p1848161 VALUES IN ("1848161"),
        PARTITION p1848177 VALUES IN ("1848177"),
        PARTITION p1848197 VALUES IN ("1848197"),
        PARTITION p1848218 VALUES IN ("1848218"))
        DISTRIBUTED BY HASH(`khh`) BUCKETS 16
        PROPERTIES (
        "colocate_with" = "test_colocate_join_with_different_tabletsgroup1",
        "replication_allocation" = "tag.location.default: 1"
        );

        insert into USR_V_KHZHSJ_ES_POC1 values(10000007, 10000007);
        insert into USR_V_KHZHSJ_ES_POC1 values(10000007, 10000007);
        insert into USR_V_KHZHSJ_ES_POC1 values(10000007, 10000007);

        insert into USR_TLBL_VAL_R1 values(48414, 10000007);
        insert into USR_TLBL_VAL_R1 values(94460, 10000007);
        insert into USR_TLBL_VAL_R1 values(60426, 10000007);
    """
    qt_sql """ select  *    from  USR_V_KHZHSJ_ES_POC1  A,USR_TLBL_VAL_R1  B  WHERE  A.khid  =  B.khh order by lbl_id; """

    multi_sql """
    drop table if exists USR_TLBL_VAL_R;
    
    drop table if exists USR_V_KHZHSJ_ES_POC;
    
    CREATE TABLE `USR_TLBL_VAL_R` (
        `lbl_id` bigint NOT NULL,
        `khh` bigint NULL,
        `lbl_clss_id` bigint NULL,
        `lbl_clss_nm` text NULL,
        `lbl_type_id` bigint NULL,
        `lbl_type_name` text NULL,
        `lbl_nm` text NULL,
        `lbl_val_id` bigint NULL,
        `lbl_val_code` text NULL,
        `lbl_val_name` text NULL,
        `lbl_val_dsc` text NULL,
        `jsrq` int NULL
    ) ENGINE = OLAP DUPLICATE KEY(`lbl_id`, `khh`, `lbl_clss_id`) PARTITION BY LIST (`lbl_id`) (
        PARTITION p0
        VALUES
            IN ("0"),
            PARTITION p1
        VALUES
            IN ("1"),
            PARTITION p29
        VALUES
            IN ("29"),
            PARTITION p35
        VALUES
            IN ("35"),
            PARTITION p57
        VALUES
            IN ("57"),
            PARTITION p352
        VALUES
            IN ("352"),
            PARTITION p402
        VALUES
            IN ("402"),
            PARTITION p523
        VALUES
            IN ("523"),
            PARTITION p2347
        VALUES
            IN ("2347"),
            PARTITION p10376
        VALUES
            IN ("10376"),
            PARTITION p42408
        VALUES
            IN ("42408"),
            PARTITION p44410
        VALUES
            IN ("44410"),
            PARTITION p48414
        VALUES
            IN ("48414"),
            PARTITION p50416
        VALUES
            IN ("50416"),
            PARTITION p52418
        VALUES
            IN ("52418"),
            PARTITION p56422
        VALUES
            IN ("56422"),
            PARTITION p60426
        VALUES
            IN ("60426"),
            PARTITION p64430
        VALUES
            IN ("64430"),
            PARTITION p66432
        VALUES
            IN ("66432"),
            PARTITION p70436
        VALUES
            IN ("70436"),
            PARTITION p72438
        VALUES
            IN ("72438"),
            PARTITION p74440
        VALUES
            IN ("74440"),
            PARTITION p78444
        VALUES
            IN ("78444"),
            PARTITION p84450
        VALUES
            IN ("84450"),
            PARTITION p86452
        VALUES
            IN ("86452"),
            PARTITION p88454
        VALUES
            IN ("88454"),
            PARTITION p90456
        VALUES
            IN ("90456"),
            PARTITION p92458
        VALUES
            IN ("92458"),
            PARTITION p94460
        VALUES
            IN ("94460"),
            PARTITION p96462
        VALUES
            IN ("96462"),
            PARTITION p98464
        VALUES
            IN ("98464"),
            PARTITION p100466
        VALUES
            IN ("100466"),
            PARTITION p102468
        VALUES
            IN ("102468"),
            PARTITION p104470
        VALUES
            IN ("104470"),
            PARTITION p106472
        VALUES
            IN ("106472"),
            PARTITION p108474
        VALUES
            IN ("108474"),
            PARTITION p110476
        VALUES
            IN ("110476"),
            PARTITION p112478
        VALUES
            IN ("112478"),
            PARTITION p114480
        VALUES
            IN ("114480"),
            PARTITION p122488
        VALUES
            IN ("122488"),
            PARTITION p124490
        VALUES
            IN ("124490"),
            PARTITION p126492
        VALUES
            IN ("126492"),
            PARTITION p130496
        VALUES
            IN ("130496"),
            PARTITION p134500
        VALUES
            IN ("134500"),
            PARTITION p150516
        VALUES
            IN ("150516"),
            PARTITION p154520
        VALUES
            IN ("154520"),
            PARTITION p158524
        VALUES
            IN ("158524"),
            PARTITION p158525
        VALUES
            IN ("158525"),
            PARTITION p1848141
        VALUES
            IN ("1848141"),
            PARTITION p1848161
        VALUES
            IN ("1848161"),
            PARTITION p1848177
        VALUES
            IN ("1848177"),
            PARTITION p1848197
        VALUES
            IN ("1848197"),
            PARTITION p1848218
        VALUES
            IN ("1848218")
    ) DISTRIBUTED BY HASH(`khh`) BUCKETS 16 PROPERTIES (
        "replication_allocation" = "tag.location.default: 1",
        "min_load_replica_num" = "-1",
        "is_being_synced" = "false",
        "colocate_with" = "USR_TLBL_VAL_R_group1",
        "storage_medium" = "hdd",
        "storage_format" = "V2",
        "inverted_index_storage_format" = "V2",
        "light_schema_change" = "true",
        "disable_auto_compaction" = "false",
        "binlog.enable" = "false",
        "binlog.ttl_seconds" = "86400",
        "binlog.max_bytes" = "9223372036854775807",
        "binlog.max_history_nums" = "9223372036854775807",
        "enable_single_replica_compaction" = "false",
        "group_commit_interval_ms" = "10000",
        "group_commit_data_bytes" = "134217728"
    );
    
    CREATE TABLE `USR_V_KHZHSJ_ES_POC` (
        `khid` bigint NULL,
        `khh` bigint NULL,
        `khxm` text NULL,
        `zjzh` text NULL,
        `xyzjzh` text NULL,
        `yhdm` text NULL,
        `yhmc` text NULL,
        `sj` text NULL,
        `fwsj` text NULL,
        `dh` text NULL,
        `email` text NULL,
        `hundsun` text NULL,
        `ths` text NULL,
        `wx` text NULL,
        `vld_sj` smallint NULL,
        `vld_email` smallint NULL,
        `vld_hundsun` smallint NULL,
        `vld_ths` smallint NULL,
        `vld_wx` smallint NULL,
        `yyb` smallint NULL,
        `yybmc` text NULL,
        `khyyb` bigint NULL,
        `khyybmc` text NULL,
        `khlx` bigint NULL,
        `khlxmc` text NULL,
        `ptzh_khrq` int NULL,
        `rzrq_khrq` int NULL,
        `ggqq_khrq` int NULL,
        `jrcp_khrq` int NULL,
        `khzt` smallint NULL,
        `khztmc` text NULL,
        `khfs` bigint NULL,
        `khfsmc` text NULL,
        `xhrq` int NULL,
        `fxcsnl` bigint NULL,
        `fxcsnlmc` text NULL,
        `fxph` bigint NULL,
        `fxphmc` text NULL,
        `zhfxtz` bigint NULL,
        `zhfxtzmc` text NULL,
        `fxdjpcyxq` int NULL,
        `tzzjb` int NULL,
        `tzzjbmc` text NULL,
        `tzzfl` bigint NULL,
        `tzzflmc` text NULL,
        `tzzflyxq` int NULL,
        `tzpz` bigint NULL,
        `tzpzmc` text NULL,
        `csrq` int NULL,
        `csyr` text NULL,
        `mdrxm` text NULL,
        `mdrxmmc` text NULL,
        `phlxfs` text NULL,
        `phlxfsmc` text NULL,
        `phlxsj` text NULL,
        `phlxsjmc` text NULL,
        `sfktlczh` text NULL,
        `ktywqx` text NULL,
        `ktywqxmc` text NULL,
        `ktywpz` text NULL,
        `ktywpzmc` text NULL,
        `yqxkt` text NULL,
        `yqxktmc` text NULL,
        `zjlb` bigint NULL,
        `zjlbmc` text NULL,
        `zjbh` text NULL,
        `zjyxq` text NULL,
        `xb` bigint NULL,
        `xbmc` text NULL,
        `rzrq_xypf` decimal(16, 2) NULL,
        `rzrq_xydj` int NULL,
        `xydjmc` text NULL,
        `rzrq_rzsxed` decimal(16, 2) NULL,
        `rzrq_rqsxed` decimal(16, 2) NULL,
        `sxzed` decimal(16, 2) NULL,
        `kyed` decimal(16, 2) NULL,
        `tzgwmc` text NULL,
        `khjlmc` text NULL,
        `fwrymc` text NULL,
        `zsz` decimal(16, 2) NULL,
        `ptzh_sz` decimal(16, 2) NULL,
        `rzrq_sz` decimal(16, 2) NULL,
        `jrcp_sz` decimal(16, 2) NULL,
        `ggqq_sz` decimal(16, 2) NULL,
        `zzjye` decimal(16, 2) NULL,
        `ptzh_zjye` decimal(16, 2) NULL,
        `rzrq_zjye` decimal(16, 2) NULL,
        `ggqq_zjye` decimal(16, 2) NULL,
        `zzc` decimal(16, 2) NULL,
        `jzc` decimal(16, 2) NULL,
        `ptzh_zc` decimal(16, 2) NULL,
        `ptzh_jzc` decimal(16, 2) NULL,
        `rzrq_zc` decimal(16, 2) NULL,
        `rzrq_jzc` decimal(16, 2) NULL,
        `kybzj` decimal(16, 2) NULL,
        `rzrq_zfz` decimal(16, 2) NULL,
        `dbbl` decimal(19, 6) NULL,
        `ptyjl` decimal(12, 5) NULL,
        `xyyjl_pt` decimal(12, 5) NULL,
        `xyyjl_xy` decimal(12, 5) NULL,
        `ggqq_zc` decimal(16, 2) NULL,
        `jyy_fzzc` decimal(16, 2) NULL,
        `jsy_fzzc` decimal(16, 2) NULL,
        `jbn_fzzc` decimal(16, 2) NULL,
        `jyn_fzzc` decimal(16, 2) NULL,
        `ls_fzzc` decimal(16, 2) NULL,
        `ptzh_jyy_fzzc` decimal(16, 2) NULL,
        `ptzh_jsy_fzzc` decimal(16, 2) NULL,
        `ptzh_jbn_fzzc` decimal(16, 2) NULL,
        `ptzh_jyn_fzzc` decimal(16, 2) NULL,
        `ptzh_ls_fzzc` decimal(16, 2) NULL,
        `rzrq_jyy_fzzc` decimal(16, 2) NULL,
        `rzrq_jsy_fzzc` decimal(16, 2) NULL,
        `rzrq_jbn_fzzc` decimal(16, 2) NULL,
        `rzrq_jyn_fzzc` decimal(16, 2) NULL,
        `rzrq_ls_fzzc` decimal(16, 2) NULL,
        `jyy_fzzc_rq` int NULL,
        `jsy_fzzc_rq` int NULL,
        `jbn_fzzc_rq` int NULL,
        `jyn_fzzc_rq` int NULL,
        `ls_fzzc_rq` int NULL,
        `ptzh_jyy_fzzc_rq` int NULL,
        `ptzh_jsy_fzzc_rq` int NULL,
        `ptzh_jbn_fzzc_rq` int NULL,
        `ptzh_jyn_fzzc_rq` int NULL,
        `ptzh_ls_fzzc_rq` int NULL,
        `rzrq_jyy_fzzc_rq` int NULL,
        `rzrq_jsy_fzzc_rq` int NULL,
        `rzrq_jbn_fzzc_rq` int NULL,
        `rzrq_jyn_fzzc_rq` int NULL,
        `rzrq_ls_fzzc_rq` int NULL,
        `jyy_fzjzc` decimal(16, 2) NULL,
        `jsy_fzjzc` decimal(16, 2) NULL,
        `jbn_fzjzc` decimal(16, 2) NULL,
        `jyn_fzjzc` decimal(16, 2) NULL,
        `ls_fzjzc` decimal(16, 2) NULL,
        `ptzh_jyy_fzjzc` decimal(16, 2) NULL,
        `ptzh_jsy_fzjzc` decimal(16, 2) NULL,
        `ptzh_jbn_fzjzc` decimal(16, 2) NULL,
        `ptzh_jyn_fzjzc` decimal(16, 2) NULL,
        `ptzh_ls_fzjzc` decimal(16, 2) NULL,
        `rzrq_jyy_fzjzc` decimal(16, 2) NULL,
        `rzrq_jsy_fzjzc` decimal(16, 2) NULL,
        `rzrq_jbn_fzjzc` decimal(16, 2) NULL,
        `rzrq_jyn_fzjzc` decimal(16, 2) NULL,
        `rzrq_ls_fzjzc` decimal(16, 2) NULL,
        `jyy_fzjzc_rq` decimal(16, 2) NULL,
        `jsy_fzjzc_rq` decimal(16, 2) NULL,
        `jbn_fzjzc_rq` decimal(16, 2) NULL,
        `jyn_fzjzc_rq` decimal(16, 2) NULL,
        `ls_fzjzc_rq` decimal(16, 2) NULL,
        `ptzh_jyy_fzjzc_rq` decimal(16, 2) NULL,
        `ptzh_jsy_fzjzc_rq` decimal(16, 2) NULL,
        `ptzh_jbn_fzjzc_rq` decimal(16, 2) NULL,
        `ptzh_jyn_fzjzc_rq` decimal(16, 2) NULL,
        `ptzh_ls_fzjzc_rq` decimal(16, 2) NULL,
        `rzrq_jyy_fzjzc_rq` decimal(16, 2) NULL,
        `rzrq_jsy_fzjzc_rq` decimal(16, 2) NULL,
        `rzrq_jbn_fzjzc_rq` decimal(16, 2) NULL,
        `rzrq_jyn_fzjzc_rq` decimal(16, 2) NULL,
        `rzrq_ls_fzjzc_rq` decimal(16, 2) NULL,
        `jyy_bgzc` decimal(16, 2) NULL,
        `jsy_bgzc` decimal(16, 2) NULL,
        `jbn_bgzc` decimal(16, 2) NULL,
        `jyn_bgzc` decimal(16, 2) NULL,
        `ls_bgzc` decimal(16, 2) NULL,
        `ptzh_jyy_bgzc` decimal(16, 2) NULL,
        `ptzh_jsy_bgzc` decimal(16, 2) NULL,
        `ptzh_jbn_bgzc` decimal(16, 2) NULL,
        `ptzh_jyn_bgzc` decimal(16, 2) NULL,
        `ptzh_ls_bgzc` decimal(16, 2) NULL,
        `rzrq_jyy_bgzc` decimal(16, 2) NULL,
        `rzrq_jsy_bgzc` decimal(16, 2) NULL,
        `rzrq_jbn_bgzc` decimal(16, 2) NULL,
        `rzrq_jyn_bgzc` decimal(16, 2) NULL,
        `rzrq_ls_bgzc` decimal(16, 2) NULL,
        `jyy_bgzc_rq` decimal(16, 2) NULL,
        `jsy_bgzc_rq` decimal(16, 2) NULL,
        `jbn_bgzc_rq` decimal(16, 2) NULL,
        `jyn_bgzc_rq` decimal(16, 2) NULL,
        `ls_bgzc_rq` decimal(16, 2) NULL,
        `ptzh_jyy_bgzc_rq` decimal(16, 2) NULL,
        `ptzh_jsy_bgzc_rq` decimal(16, 2) NULL,
        `ptzh_jbn_bgzc_rq` decimal(16, 2) NULL,
        `ptzh_jyn_bgzc_rq` decimal(16, 2) NULL,
        `ptzh_ls_bgzc_rq` decimal(16, 2) NULL,
        `rzrq_jyy_bgzc_rq` decimal(16, 2) NULL,
        `rzrq_jsy_bgzc_rq` decimal(16, 2) NULL,
        `rzrq_jbn_bgzc_rq` decimal(16, 2) NULL,
        `rzrq_jyn_bgzc_rq` decimal(16, 2) NULL,
        `rzrq_ls_bgzc_rq` decimal(16, 2) NULL,
        `by_rjzc` decimal(16, 2) NULL,
        `bn_rjzc` decimal(16, 2) NULL,
        `jyn_rjzc` decimal(16, 2) NULL,
        `ptzh_by_rjzc` decimal(16, 2) NULL,
        `ptzh_bn_rjzc` decimal(16, 2) NULL,
        `ptzh_jyn_rjzc` decimal(16, 2) NULL,
        `rzrq_by_rjzc` decimal(16, 2) NULL,
        `rzrq_bn_rjzc` decimal(16, 2) NULL,
        `rzrq_jyn_rjzc` decimal(16, 2) NULL,
        `jrcp_by_rjzc` decimal(16, 2) NULL,
        `jrcp_bn_rjzc` decimal(16, 2) NULL,
        `jrcp_jyn_rjzc` decimal(16, 2) NULL,
        `ggqq_by_rjzc` decimal(16, 2) NULL,
        `ggqq_bn_rjzc` decimal(16, 2) NULL,
        `ggqq_jyn_rjzc` decimal(16, 2) NULL,
        `sz_zcjlr` decimal(16, 2) NULL,
        `bz_zcjlr` decimal(16, 2) NULL,
        `sy_zcjlr` decimal(16, 2) NULL,
        `by_zcjlr` decimal(16, 2) NULL,
        `jyn_zcjlr` decimal(16, 2) NULL,
        `jyy_zcjlr` decimal(16, 2) NULL,
        `sn_zcjlr` decimal(16, 2) NULL,
        `bn_zcjlr` decimal(16, 2) NULL,
        `ptzh_sz_zcjlr` decimal(16, 2) NULL,
        `ptzh_bz_zcjlr` decimal(16, 2) NULL,
        `ptzh_sy_zcjlr` decimal(16, 2) NULL,
        `ptzh_by_zcjlr` decimal(16, 2) NULL,
        `ptzh_jyn_zcjlr` decimal(16, 2) NULL,
        `ptzh_jyy_zcjlr` decimal(16, 2) NULL,
        `ptzh_sn_zcjlr` decimal(16, 2) NULL,
        `ptzh_bn_zcjlr` decimal(16, 2) NULL,
        `rzrq_sz_zcjlr` decimal(16, 2) NULL,
        `rzrq_bz_zcjlr` decimal(16, 2) NULL,
        `rzrq_sy_zcjlr` decimal(16, 2) NULL,
        `rzrq_by_zcjlr` decimal(16, 2) NULL,
        `rzrq_jyn_zcjlr` decimal(16, 2) NULL,
        `rzrq_jyy_zcjlr` decimal(16, 2) NULL,
        `rzrq_sn_zcjlr` decimal(16, 2) NULL,
        `rzrq_bn_zcjlr` decimal(16, 2) NULL,
        `sz_ykl` decimal(22, 6) NULL,
        `bz_ykl` decimal(22, 6) NULL,
        `sy_ykl` decimal(22, 6) NULL,
        `by_ykl` decimal(22, 6) NULL,
        `jyn_ykl` decimal(22, 6) NULL,
        `sn_ykl` decimal(22, 6) NULL,
        `bn_ykl` decimal(22, 6) NULL,
        `ptzh_sz_ykl` decimal(22, 6) NULL,
        `ptzh_bz_ykl` decimal(22, 6) NULL,
        `ptzh_sy_ykl` decimal(22, 6) NULL,
        `ptzh_by_ykl` decimal(22, 6) NULL,
        `ptzh_jyn_ykl` decimal(22, 6) NULL,
        `ptzh_sn_ykl` decimal(22, 6) NULL,
        `ptzh_bn_ykl` decimal(22, 6) NULL,
        `rzrq_sz_ykl` decimal(22, 6) NULL,
        `rzrq_bz_ykl` decimal(22, 6) NULL,
        `rzrq_sy_ykl` decimal(22, 6) NULL,
        `rzrq_by_ykl` decimal(22, 6) NULL,
        `rzrq_jyn_ykl` decimal(22, 6) NULL,
        `rzrq_sn_ykl` decimal(22, 6) NULL,
        `rzrq_bn_ykl` decimal(22, 6) NULL,
        `cw` decimal(16, 2) NULL,
        `ptzh_cw` decimal(16, 2) NULL,
        `rzrq_cw` decimal(16, 2) NULL,
        `sz_jyl` decimal(16, 2) NULL,
        `bz_jyl` decimal(16, 2) NULL,
        `sy_jyl` decimal(16, 2) NULL,
        `by_jyl` decimal(16, 2) NULL,
        `jyn_jyl` decimal(16, 2) NULL,
        `sn_jyl` decimal(16, 2) NULL,
        `bn_jyl` decimal(16, 2) NULL,
        `ptzh_sz_jyl` decimal(16, 2) NULL,
        `ptzh_bz_jyl` decimal(16, 2) NULL,
        `ptzh_sy_jyl` decimal(16, 2) NULL,
        `ptzh_by_jyl` decimal(16, 2) NULL,
        `ptzh_jyn_jyl` decimal(16, 2) NULL,
        `ptzh_sn_jyl` decimal(16, 2) NULL,
        `ptzh_bn_jyl` decimal(16, 2) NULL,
        `rzrq_sz_jyl` decimal(16, 2) NULL,
        `rzrq_bz_jyl` decimal(16, 2) NULL,
        `rzrq_sy_jyl` decimal(16, 2) NULL,
        `rzrq_by_jyl` decimal(16, 2) NULL,
        `rzrq_jyn_jyl` decimal(16, 2) NULL,
        `rzrq_sn_jyl` decimal(16, 2) NULL,
        `rzrq_bn_jyl` decimal(16, 2) NULL,
        `sz_jyl_mr` decimal(16, 2) NULL,
        `bz_jyl_mr` decimal(16, 2) NULL,
        `sy_jyl_mr` decimal(16, 2) NULL,
        `by_jyl_mr` decimal(16, 2) NULL,
        `jyn_jyl_mr` decimal(16, 2) NULL,
        `sn_jyl_mr` decimal(16, 2) NULL,
        `bn_jyl_mr` decimal(16, 2) NULL,
        `ptzh_sz_jyl_mr` decimal(16, 2) NULL,
        `ptzh_bz_jyl_mr` decimal(16, 2) NULL,
        `ptzh_sy_jyl_mr` decimal(16, 2) NULL,
        `ptzh_by_jyl_mr` decimal(16, 2) NULL,
        `ptzh_jyn_jyl_mr` decimal(16, 2) NULL,
        `ptzh_sn_jyl_mr` decimal(16, 2) NULL,
        `ptzh_bn_jyl_mr` decimal(16, 2) NULL,
        `rzrq_sz_jyl_mr` decimal(16, 2) NULL,
        `rzrq_bz_jyl_mr` decimal(16, 2) NULL,
        `rzrq_sy_jyl_mr` decimal(16, 2) NULL,
        `rzrq_by_jyl_mr` decimal(16, 2) NULL,
        `rzrq_jyn_jyl_mr` decimal(16, 2) NULL,
        `rzrq_sn_jyl_mr` decimal(16, 2) NULL,
        `rzrq_bn_jyl_mr` decimal(16, 2) NULL,
        `sz_jyl_mc` decimal(16, 2) NULL,
        `bz_jyl_mc` decimal(16, 2) NULL,
        `sy_jyl_mc` decimal(16, 2) NULL,
        `by_jyl_mc` decimal(16, 2) NULL,
        `jyn_jyl_mc` decimal(16, 2) NULL,
        `sn_jyl_mc` decimal(16, 2) NULL,
        `bn_jyl_mc` decimal(16, 2) NULL,
        `ptzh_sz_jyl_mc` decimal(16, 2) NULL,
        `ptzh_bz_jyl_mc` decimal(16, 2) NULL,
        `ptzh_sy_jyl_mc` decimal(16, 2) NULL,
        `ptzh_by_jyl_mc` decimal(16, 2) NULL,
        `ptzh_jyn_jyl_mc` decimal(16, 2) NULL,
        `ptzh_sn_jyl_mc` decimal(16, 2) NULL,
        `ptzh_bn_jyl_mc` decimal(16, 2) NULL,
        `rzrq_sz_jyl_mc` decimal(16, 2) NULL,
        `rzrq_bz_jyl_mc` decimal(16, 2) NULL,
        `rzrq_sy_jyl_mc` decimal(16, 2) NULL,
        `rzrq_by_jyl_mc` decimal(16, 2) NULL,
        `rzrq_jyn_jyl_mc` decimal(16, 2) NULL,
        `rzrq_sn_jyl_mc` decimal(16, 2) NULL,
        `rzrq_bn_jyl_mc` decimal(16, 2) NULL,
        `sz_yj` decimal(16, 2) NULL,
        `bz_yj` decimal(16, 2) NULL,
        `sy_yj` decimal(16, 2) NULL,
        `by_yj` decimal(16, 2) NULL,
        `jyn_yj` decimal(16, 2) NULL,
        `sn_yj` decimal(16, 2) NULL,
        `bn_yj` decimal(16, 2) NULL,
        `ptzh_sz_yj` decimal(16, 2) NULL,
        `ptzh_bz_yj` decimal(16, 2) NULL,
        `ptzh_sy_yj` decimal(16, 2) NULL,
        `ptzh_by_yj` decimal(16, 2) NULL,
        `ptzh_jyn_yj` decimal(16, 2) NULL,
        `ptzh_sn_yj` decimal(16, 2) NULL,
        `ptzh_bn_yj` decimal(16, 2) NULL,
        `rzrq_sz_yj` decimal(16, 2) NULL,
        `rzrq_bz_yj` decimal(16, 2) NULL,
        `rzrq_sy_yj` decimal(16, 2) NULL,
        `rzrq_by_yj` decimal(16, 2) NULL,
        `rzrq_jyn_yj` decimal(16, 2) NULL,
        `rzrq_sn_yj` decimal(16, 2) NULL,
        `rzrq_bn_yj` decimal(16, 2) NULL,
        `sz_yjl` decimal(22, 6) NULL,
        `bz_yjl` decimal(22, 6) NULL,
        `sy_yjl` decimal(22, 6) NULL,
        `by_yjl` decimal(22, 6) NULL,
        `ptzh_sz_yjl` decimal(22, 6) NULL,
        `ptzh_bz_yjl` decimal(22, 6) NULL,
        `ptzh_sy_yjl` decimal(22, 6) NULL,
        `ptzh_by_yjl` decimal(22, 6) NULL,
        `ptzh_jyn_yjl` decimal(22, 6) NULL,
        `rzrq_sz_yjl` decimal(22, 6) NULL,
        `rzrq_bz_yjl` decimal(22, 6) NULL,
        `rzrq_sy_yjl` decimal(22, 6) NULL,
        `rzrq_by_yjl` decimal(22, 6) NULL,
        `rzrq_jyn_yjl` decimal(22, 6) NULL,
        `sz_zzl` decimal(16, 2) NULL,
        `bz_zzl` decimal(16, 2) NULL,
        `sy_zzl` decimal(16, 2) NULL,
        `by_zzl` decimal(16, 2) NULL,
        `jyn_zzl` decimal(16, 2) NULL,
        `sn_zzl` decimal(16, 2) NULL,
        `bn_zzl` decimal(16, 2) NULL,
        `ptzh_sz_zzl` decimal(16, 2) NULL,
        `ptzh_bz_zzl` decimal(16, 2) NULL,
        `ptzh_sy_zzl` decimal(16, 2) NULL,
        `ptzh_by_zzl` decimal(16, 2) NULL,
        `ptzh_jyn_zzl` decimal(16, 2) NULL,
        `ptzh_sn_zzl` decimal(16, 2) NULL,
        `ptzh_bn_zzl` decimal(16, 2) NULL,
        `rzrq_sz_zzl` decimal(16, 2) NULL,
        `rzrq_bz_zzl` decimal(16, 2) NULL,
        `rzrq_sy_zzl` decimal(16, 2) NULL,
        `rzrq_by_zzl` decimal(16, 2) NULL,
        `rzrq_jyn_zzl` decimal(16, 2) NULL,
        `rzrq_sn_zzl` decimal(16, 2) NULL,
        `rzrq_bn_zzl` decimal(16, 2) NULL,
        `sz_jycs` decimal(16, 2) NULL,
        `bz_jycs` decimal(16, 2) NULL,
        `sy_jycs` decimal(16, 2) NULL,
        `by_jycs` decimal(16, 2) NULL,
        `jyn_jycs` decimal(16, 2) NULL,
        `sn_jycs` decimal(16, 2) NULL,
        `bn_jycs` decimal(16, 2) NULL,
        `ptzh_sz_jycs` decimal(16, 2) NULL,
        `ptzh_bz_jycs` decimal(16, 2) NULL,
        `ptzh_sy_jycs` decimal(16, 2) NULL,
        `ptzh_by_jycs` decimal(16, 2) NULL,
        `ptzh_jyn_jycs` decimal(16, 2) NULL,
        `ptzh_sn_jycs` decimal(16, 2) NULL,
        `ptzh_bn_jycs` decimal(16, 2) NULL,
        `rzrq_sz_jycs` decimal(16, 2) NULL,
        `rzrq_bz_jycs` decimal(16, 2) NULL,
        `rzrq_sy_jycs` decimal(16, 2) NULL,
        `rzrq_by_jycs` decimal(16, 2) NULL,
        `rzrq_jyn_jycs` decimal(16, 2) NULL,
        `rzrq_sn_jycs` decimal(16, 2) NULL,
        `rzrq_bn_jycs` decimal(16, 2) NULL,
        `ptzh_zjjyrq` int NULL,
        `rzrq_zjjyrq` int NULL,
        `khq` text NULL,
        `khqmc` text NULL,
        `jyy_qczc` decimal(16, 2) NULL,
        `ptzh_jyy_qczc` decimal(16, 2) NULL,
        `rzrq_jyy_qczc` decimal(16, 2) NULL,
        `jyy_jyl` decimal(16, 2) NULL,
        `ptzh_jyy_jyl` decimal(16, 2) NULL,
        `rzrq_jyy_jyl` decimal(16, 2) NULL,
        `jyy_jyl_mr` decimal(16, 2) NULL,
        `ptzh_jyy_jyl_mr` decimal(16, 2) NULL,
        `rzrq_jyy_jyl_mr` decimal(16, 2) NULL,
        `jyy_jyl_mc` decimal(16, 2) NULL,
        `ptzh_jyy_jyl_mc` decimal(16, 2) NULL,
        `rzrq_jyy_jyl_mc` decimal(16, 2) NULL,
        `jyy_yj` decimal(16, 2) NULL,
        `ptzh_jyy_yj` decimal(16, 2) NULL,
        `rzrq_jyy_yj` decimal(16, 2) NULL,
        `jyy_zzl` decimal(16, 2) NULL,
        `ptzh_jyy_zzl` decimal(16, 2) NULL,
        `rzrq_jyy_zzl` decimal(16, 2) NULL,
        `jyy_jycs` decimal(16, 2) NULL,
        `ptzh_jyy_jycs` decimal(16, 2) NULL,
        `rzrq_jyy_jycs` decimal(16, 2) NULL,
        `jbn_jycs` int NULL,
        `ptzh_jbn_jycs` int NULL,
        `rzrq_jbn_jycs` int NULL,
        `jbn_zcjlr` decimal(16, 2) NULL,
        `ptzh_jbn_zcjlr` decimal(16, 2) NULL,
        `rzrq_jbn_zcjlr` decimal(16, 2) NULL,
        `jbn_qczc` decimal(16, 2) NULL,
        `ptzh_jbn_qczc` decimal(16, 2) NULL,
        `rzrq_jbn_qczc` decimal(16, 2) NULL,
        `khjl` text NULL,
        `tzgw` text NULL,
        `fwry` text NULL,
        `ggqq_sz_qlc` decimal(16, 2) NULL,
        `ggqq_sz_ywc` decimal(16, 2) NULL,
        `rzrq_rzfz` decimal(16, 2) NULL,
        `rzrq_rqfz` decimal(16, 2) NULL,
        `rzrq_lxfz` decimal(16, 2) NULL,
        `ptzh_djje` decimal(16, 2) NULL,
        `rzrq_djje` decimal(16, 2) NULL,
        `ggqq_djje` decimal(16, 2) NULL,
        `jbn_ykl` decimal(22, 6) NULL,
        `ptzh_jbn_ykl` decimal(22, 6) NULL,
        `zzchb` decimal(16, 3) NULL,
        `jylhb` decimal(16, 3) NULL,
        `jyjhb` decimal(16, 3) NULL,
        `bn_jyj` decimal(16, 2) NULL,
        `by_jyj` decimal(16, 2) NULL,
        `rzll` decimal(9, 6) NULL,
        `rqll` decimal(9, 6) NULL,
        `rzlx` decimal(16, 2) NULL,
        `rzfx` decimal(16, 2) NULL,
        `rqfysr` decimal(16, 2) NULL,
        `rqfx` decimal(16, 2) NULL,
        `yybzj` decimal(16, 2) NULL,
        `ljqpcs_jyn` int NULL,
        `jyn_qczc` decimal(16, 2) NULL,
        `ptzh_jyn_qczc` decimal(16, 2) NULL,
        `rzrq_jyn_qczc` decimal(16, 2) NULL,
        `ztzc` decimal(16, 2) NULL,
        `zqzc` decimal(16, 2) NULL,
        `sy_rjzc` decimal(16, 2) NULL,
        `ptzh_sy_rjzc` decimal(16, 2) NULL,
        `rzrq_sy_rjzc` decimal(16, 2) NULL,
        `ggqq_sz_ykl` decimal(22, 6) NULL,
        `ggqq_bz_ykl` decimal(22, 6) NULL,
        `ggqq_sy_ykl` decimal(22, 6) NULL,
        `ggqq_by_ykl` decimal(22, 6) NULL,
        `ggqq_jyy_ykl` decimal(22, 6) NULL,
        `ggqq_jyn_ykl` decimal(22, 6) NULL,
        `ggqq_bn_ykl` decimal(22, 6) NULL,
        `ggqq_sn_ykl` decimal(22, 6) NULL,
        `jrcp_sz_jyl` decimal(16, 2) NULL,
        `jrcp_bz_jyl` decimal(16, 2) NULL,
        `jrcp_sy_jyl` decimal(16, 2) NULL,
        `jrcp_by_jyl` decimal(16, 2) NULL,
        `jrcp_jyy_jyl` decimal(16, 2) NULL,
        `jrcp_jyn_jyl` decimal(16, 2) NULL,
        `jrcp_sn_jyl` decimal(16, 2) NULL,
        `jrcp_bn_jyl` decimal(16, 2) NULL,
        `ggqq_sz_jyl` decimal(16, 2) NULL,
        `ggqq_bz_jyl` decimal(16, 2) NULL,
        `ggqq_sy_jyl` decimal(16, 2) NULL,
        `ggqq_by_jyl` decimal(16, 2) NULL,
        `ggqq_jyy_jyl` decimal(16, 2) NULL,
        `ggqq_jyn_jyl` decimal(16, 2) NULL,
        `ggqq_sn_jyl` decimal(16, 2) NULL,
        `ggqq_bn_jyl` decimal(16, 2) NULL,
        `ggqq_bn_jyl_mrkc` decimal(16, 2) NULL,
        `ggqq_bn_jyl_mrpc` decimal(16, 2) NULL,
        `ggqq_bn_jyl_mckc` decimal(16, 2) NULL,
        `ggqq_bn_jyl_mcpc` decimal(16, 2) NULL,
        `ggqq_sz_yj` decimal(16, 2) NULL,
        `ggqq_bz_yj` decimal(16, 2) NULL,
        `ggqq_sy_yj` decimal(16, 2) NULL,
        `ggqq_by_yj` decimal(16, 2) NULL,
        `ggqq_jyy_yj` decimal(16, 2) NULL,
        `ggqq_jyn_yj` decimal(16, 2) NULL,
        `ggqq_sn_yj` decimal(16, 2) NULL,
        `ggqq_bn_yj` decimal(16, 2) NULL,
        `ggqq_bn_jyj` decimal(16, 2) NULL,
        `ggqq_sz_cjsl` decimal(16, 2) NULL,
        `ggqq_bz_cjsl` decimal(16, 2) NULL,
        `ggqq_sy_cjsl` decimal(16, 2) NULL,
        `ggqq_by_cjsl` decimal(16, 2) NULL,
        `ggqq_jyy_cjsl` decimal(16, 2) NULL,
        `ggqq_jyn_cjsl` decimal(16, 2) NULL,
        `ggqq_bn_cjsl` decimal(16, 2) NULL,
        `ggqq_sn_cjsl` decimal(16, 2) NULL,
        `cl1` int NULL,
        `cl2` int NULL,
        `cl3` int NULL,
        `cl4` int NULL,
        `cl5` int NULL,
        `cl6` int NULL,
        `cl7` int NULL,
        `cl8` int NULL,
        `cl9` int NULL,
        `cl10` int NULL,
        `cl11` int NULL,
        `cl12` int NULL,
        `cl13` int NULL,
        `cl14` int NULL,
        `cl15` int NULL,
        `cl16` int NULL,
        `cl17` int NULL,
        `cl18` int NULL,
        `cl19` int NULL,
        `cl20` int NULL,
        `cl21` int NULL,
        `cl22` int NULL,
        `bn_zjjlr` decimal(16, 2) NULL,
        `ptzh_bn_zjjlr` decimal(16, 2) NULL,
        `rzrq_bn_zjjlr` decimal(16, 2) NULL,
        `rjzzc_20r` decimal(16, 2) NULL,
        `jyn_yjl` decimal(22, 6) NULL,
        `bn_zgx` decimal(16, 2) NULL,
        `bn_xc` decimal(16, 2) NULL,
        `bn_xf` decimal(16, 2) NULL,
        `otc_bn_yj` decimal(16, 2) NULL,
        `bn_yjl` decimal(22, 6) NULL,
        `ptzh_bn_yjl` decimal(22, 6) NULL,
        `rzrq_bn_yjl` decimal(22, 6) NULL,
        `sfktlr` text NULL,
        `rqlx` decimal(16, 2) NULL,
        `by_xc` decimal(16, 2) NULL,
        `by_xf` decimal(16, 2) NULL,
        `bn_zczzl` decimal(16, 2) NULL,
        `ptzh_bn_zczzl` decimal(16, 2) NULL,
        `rzrq_bn_zczzl` decimal(16, 2) NULL,
        `jyy_zczzl` decimal(16, 2) NULL,
        `ptzh_jyy_zczzl` decimal(16, 2) NULL,
        `rzrq_jyy_zczzl` decimal(16, 2) NULL,
        `jyy_rjzc` decimal(16, 2) NULL,
        `ptzh_jyy_rjzc` decimal(16, 2) NULL,
        `rzrq_jyy_rjzc` decimal(16, 2) NULL,
        `jrcp_jyy_rjzc` decimal(16, 2) NULL,
        `ggqq_jyy_rjzc` decimal(16, 2) NULL,
        `gxlx` text NULL,
        `gxlxmc` text NULL,
        `dqcycpfl` text NULL,
        `cjcycpfl` text NULL,
        `jyy_cjcycpfl` text NULL,
        `jsy_cjcycpfl` text NULL,
        `jbn_cjcycpfl` text NULL,
        `jyn_cjcycpfl` text NULL,
        `fltzc` decimal(16, 2) NULL,
        `sn_yjl` decimal(22, 6) NULL,
        `ptzh_sn_yjl` decimal(22, 6) NULL,
        `rzrq_sn_yjl` decimal(22, 6) NULL,
        `xldm` text NULL,
        `zydm` text NULL,
        `djje` decimal(16, 2) NULL,
        `khjb` bigint NULL,
        `khjbmc` text NULL,
        `xtbq` text NULL,
        `jyy_ykl` decimal(22, 6) NULL,
        `ptzh_jyy_ykl` decimal(22, 6) NULL,
        `rzrq_jyy_ykl` decimal(22, 6) NULL,
        `zfz` decimal(16, 2) NULL,
        `gmbyl` decimal(22, 2) NULL,
        `smbyl` decimal(22, 2) NULL,
        `lcbyl` decimal(22, 2) NULL,
        `bn_rjjzc` decimal(16, 2) NULL,
        `ptzh_bn_rjjzc` decimal(16, 2) NULL,
        `rzrq_bn_rjjzc` decimal(16, 2) NULL,
        `by_rjjzc` decimal(16, 2) NULL,
        `ptzh_by_rjjzc` decimal(16, 2) NULL,
        `rzrq_by_rjjzc` decimal(16, 2) NULL,
        `jyn_rjjzc` decimal(16, 2) NULL,
        `ptzh_jyn_rjjzc` decimal(16, 2) NULL,
        `rzrq_jyn_rjjzc` decimal(16, 2) NULL,
        `jyy_rjjzc` decimal(16, 2) NULL,
        `ptzh_jyy_rjjzc` decimal(16, 2) NULL,
        `rzrq_jyy_rjjzc` decimal(16, 2) NULL,
        `jsy_zcjlr` decimal(16, 2) NULL,
        `ptzh_jsy_zcjlr` decimal(16, 2) NULL,
        `rzrq_jsy_zcjlr` decimal(16, 2) NULL,
        `ry` text NULL,
        `rymc` text NULL,
        `sz_zgx` decimal(16, 2) NULL,
        `sy_zgx` decimal(16, 2) NULL,
        `sn_zgx` decimal(16, 2) NULL,
        `bz_zgx` decimal(16, 2) NULL,
        `by_zgx` decimal(16, 2) NULL,
        `jyy_zgx` decimal(16, 2) NULL,
        `jbn_zgx` decimal(16, 2) NULL,
        `jyn_zgx` decimal(16, 2) NULL,
        `nl` int NULL,
        `xlmc` text NULL,
        `ylqd_short_code` text NULL,
        `ylqd_name` text NULL,
        `bn_fzzc` decimal(22, 2) NULL,
        `sfktptzh` text NULL,
        `sfktxyzh` text NULL,
        `sfktqqzh` text NULL,
        `zjjyrq` text NULL,
        `tznx` text NULL,
        `level_one` text NULL,
        `level_name_tw` text NULL,
        `level_name_five` text NULL,
        `level_tw` text NULL,
        `level_thr` text NULL,
        `level_four` text NULL,
        `level_five` text NULL,
        `level_name_one` text NULL,
        `level_name_thr` text NULL,
        `level_name_four` text NULL,
        `get_customer_source` text NULL,
        `get_customer_source_name` text NULL,
        `jjtg` decimal(16, 2) NULL,
        `wbzcgs` decimal(16, 2) NULL,
        `jszh` text NULL,
        `ptzjzh` text NULL,
        `bmlb` text NULL,
        `bmmc` text NULL,
        `zq` text NULL,
        `zqname` text NULL,
        `xsg` decimal(16, 2) NULL
    ) ENGINE = OLAP DUPLICATE KEY(`khid`, `khh`) DISTRIBUTED BY HASH(`khid`) BUCKETS 16 PROPERTIES (
        "replication_allocation" = "tag.location.default: 1",
        "min_load_replica_num" = "-1",
        "bloom_filter_columns" = "khh",
        "is_being_synced" = "false",
        "colocate_with" = "USR_TLBL_VAL_R_group1",
        "storage_medium" = "hdd",
        "storage_format" = "V2",
        "inverted_index_storage_format" = "V2",
        "light_schema_change" = "true",
        "disable_auto_compaction" = "false",
        "binlog.enable" = "false",
        "enable_single_replica_compaction" = "false"
    )
    """

    multi_sql """
    INSERT INTO
        USR_V_KHZHSJ_ES_POC (
            khid,
            khh,
            khxm,
            zjzh,
            xyzjzh,
            yhdm,
            yhmc,
            sj,
            fwsj,
            dh,
            email,
            hundsun,
            ths,
            wx,
            vld_sj,
            vld_email,
            vld_hundsun,
            vld_ths,
            vld_wx,
            yyb,
            yybmc,
            khyyb,
            khyybmc,
            khlx,
            khlxmc,
            ptzh_khrq,
            rzrq_khrq,
            ggqq_khrq,
            jrcp_khrq,
            khzt,
            khztmc,
            khfs,
            khfsmc,
            xhrq,
            fxcsnl,
            fxcsnlmc,
            fxph,
            fxphmc,
            zhfxtz,
            zhfxtzmc,
            fxdjpcyxq,
            tzzjb,
            tzzjbmc,
            tzzfl,
            tzzflmc,
            tzzflyxq,
            tzpz,
            tzpzmc,
            csrq,
            csyr,
            mdrxm,
            mdrxmmc,
            phlxfs,
            phlxfsmc,
            phlxsj,
            phlxsjmc,
            sfktlczh,
            ktywqx,
            ktywqxmc,
            ktywpz,
            ktywpzmc,
            yqxkt,
            yqxktmc,
            zjlb,
            zjlbmc,
            zjbh,
            zjyxq,
            xb,
            xbmc,
            rzrq_xypf,
            rzrq_xydj,
            xydjmc,
            rzrq_rzsxed,
            rzrq_rqsxed,
            sxzed,
            kyed,
            tzgwmc,
            khjlmc,
            fwrymc,
            zsz,
            ptzh_sz,
            rzrq_sz,
            jrcp_sz,
            ggqq_sz,
            zzjye,
            ptzh_zjye,
            rzrq_zjye,
            ggqq_zjye,
            zzc,
            jzc,
            ptzh_zc,
            ptzh_jzc,
            rzrq_zc,
            rzrq_jzc,
            kybzj,
            rzrq_zfz,
            dbbl,
            ptyjl,
            xyyjl_pt,
            xyyjl_xy,
            ggqq_zc,
            jyy_fzzc,
            jsy_fzzc,
            jbn_fzzc,
            jyn_fzzc,
            ls_fzzc,
            ptzh_jyy_fzzc,
            ptzh_jsy_fzzc,
            ptzh_jbn_fzzc,
            ptzh_jyn_fzzc,
            ptzh_ls_fzzc,
            rzrq_jyy_fzzc,
            rzrq_jsy_fzzc,
            rzrq_jbn_fzzc,
            rzrq_jyn_fzzc,
            rzrq_ls_fzzc,
            jyy_fzzc_rq,
            jsy_fzzc_rq,
            jbn_fzzc_rq,
            jyn_fzzc_rq,
            ls_fzzc_rq,
            ptzh_jyy_fzzc_rq,
            ptzh_jsy_fzzc_rq,
            ptzh_jbn_fzzc_rq,
            ptzh_jyn_fzzc_rq,
            ptzh_ls_fzzc_rq,
            rzrq_jyy_fzzc_rq,
            rzrq_jsy_fzzc_rq,
            rzrq_jbn_fzzc_rq,
            rzrq_jyn_fzzc_rq,
            rzrq_ls_fzzc_rq,
            jyy_fzjzc,
            jsy_fzjzc,
            jbn_fzjzc,
            jyn_fzjzc,
            ls_fzjzc,
            ptzh_jyy_fzjzc,
            ptzh_jsy_fzjzc,
            ptzh_jbn_fzjzc,
            ptzh_jyn_fzjzc,
            ptzh_ls_fzjzc,
            rzrq_jyy_fzjzc,
            rzrq_jsy_fzjzc,
            rzrq_jbn_fzjzc,
            rzrq_jyn_fzjzc,
            rzrq_ls_fzjzc,
            jyy_fzjzc_rq,
            jsy_fzjzc_rq,
            jbn_fzjzc_rq,
            jyn_fzjzc_rq,
            ls_fzjzc_rq,
            ptzh_jyy_fzjzc_rq,
            ptzh_jsy_fzjzc_rq,
            ptzh_jbn_fzjzc_rq,
            ptzh_jyn_fzjzc_rq,
            ptzh_ls_fzjzc_rq,
            rzrq_jyy_fzjzc_rq,
            rzrq_jsy_fzjzc_rq,
            rzrq_jbn_fzjzc_rq,
            rzrq_jyn_fzjzc_rq,
            rzrq_ls_fzjzc_rq,
            jyy_bgzc,
            jsy_bgzc,
            jbn_bgzc,
            jyn_bgzc,
            ls_bgzc,
            ptzh_jyy_bgzc,
            ptzh_jsy_bgzc,
            ptzh_jbn_bgzc,
            ptzh_jyn_bgzc,
            ptzh_ls_bgzc,
            rzrq_jyy_bgzc,
            rzrq_jsy_bgzc,
            rzrq_jbn_bgzc,
            rzrq_jyn_bgzc,
            rzrq_ls_bgzc,
            jyy_bgzc_rq,
            jsy_bgzc_rq,
            jbn_bgzc_rq,
            jyn_bgzc_rq,
            ls_bgzc_rq,
            ptzh_jyy_bgzc_rq,
            ptzh_jsy_bgzc_rq,
            ptzh_jbn_bgzc_rq,
            ptzh_jyn_bgzc_rq,
            ptzh_ls_bgzc_rq,
            rzrq_jyy_bgzc_rq,
            rzrq_jsy_bgzc_rq,
            rzrq_jbn_bgzc_rq,
            rzrq_jyn_bgzc_rq,
            rzrq_ls_bgzc_rq,
            by_rjzc,
            bn_rjzc,
            jyn_rjzc,
            ptzh_by_rjzc,
            ptzh_bn_rjzc,
            ptzh_jyn_rjzc,
            rzrq_by_rjzc,
            rzrq_bn_rjzc,
            rzrq_jyn_rjzc,
            jrcp_by_rjzc,
            jrcp_bn_rjzc,
            jrcp_jyn_rjzc,
            ggqq_by_rjzc,
            ggqq_bn_rjzc,
            ggqq_jyn_rjzc,
            sz_zcjlr,
            bz_zcjlr,
            sy_zcjlr,
            by_zcjlr,
            jyn_zcjlr,
            jyy_zcjlr,
            sn_zcjlr,
            bn_zcjlr,
            ptzh_sz_zcjlr,
            ptzh_bz_zcjlr,
            ptzh_sy_zcjlr,
            ptzh_by_zcjlr,
            ptzh_jyn_zcjlr,
            ptzh_jyy_zcjlr,
            ptzh_sn_zcjlr,
            ptzh_bn_zcjlr,
            rzrq_sz_zcjlr,
            rzrq_bz_zcjlr,
            rzrq_sy_zcjlr,
            rzrq_by_zcjlr,
            rzrq_jyn_zcjlr,
            rzrq_jyy_zcjlr,
            rzrq_sn_zcjlr,
            rzrq_bn_zcjlr,
            sz_ykl,
            bz_ykl,
            sy_ykl,
            by_ykl,
            jyn_ykl,
            sn_ykl,
            bn_ykl,
            ptzh_sz_ykl,
            ptzh_bz_ykl,
            ptzh_sy_ykl,
            ptzh_by_ykl,
            ptzh_jyn_ykl,
            ptzh_sn_ykl,
            ptzh_bn_ykl,
            rzrq_sz_ykl,
            rzrq_bz_ykl,
            rzrq_sy_ykl,
            rzrq_by_ykl,
            rzrq_jyn_ykl,
            rzrq_sn_ykl,
            rzrq_bn_ykl,
            cw,
            ptzh_cw,
            rzrq_cw,
            sz_jyl,
            bz_jyl,
            sy_jyl,
            by_jyl,
            jyn_jyl,
            sn_jyl,
            bn_jyl,
            ptzh_sz_jyl,
            ptzh_bz_jyl,
            ptzh_sy_jyl,
            ptzh_by_jyl,
            ptzh_jyn_jyl,
            ptzh_sn_jyl,
            ptzh_bn_jyl,
            rzrq_sz_jyl,
            rzrq_bz_jyl,
            rzrq_sy_jyl,
            rzrq_by_jyl,
            rzrq_jyn_jyl,
            rzrq_sn_jyl,
            rzrq_bn_jyl,
            sz_jyl_mr,
            bz_jyl_mr,
            sy_jyl_mr,
            by_jyl_mr,
            jyn_jyl_mr,
            sn_jyl_mr,
            bn_jyl_mr,
            ptzh_sz_jyl_mr,
            ptzh_bz_jyl_mr,
            ptzh_sy_jyl_mr,
            ptzh_by_jyl_mr,
            ptzh_jyn_jyl_mr,
            ptzh_sn_jyl_mr,
            ptzh_bn_jyl_mr,
            rzrq_sz_jyl_mr,
            rzrq_bz_jyl_mr,
            rzrq_sy_jyl_mr,
            rzrq_by_jyl_mr,
            rzrq_jyn_jyl_mr,
            rzrq_sn_jyl_mr,
            rzrq_bn_jyl_mr,
            sz_jyl_mc,
            bz_jyl_mc,
            sy_jyl_mc,
            by_jyl_mc,
            jyn_jyl_mc,
            sn_jyl_mc,
            bn_jyl_mc,
            ptzh_sz_jyl_mc,
            ptzh_bz_jyl_mc,
            ptzh_sy_jyl_mc,
            ptzh_by_jyl_mc,
            ptzh_jyn_jyl_mc,
            ptzh_sn_jyl_mc,
            ptzh_bn_jyl_mc,
            rzrq_sz_jyl_mc,
            rzrq_bz_jyl_mc,
            rzrq_sy_jyl_mc,
            rzrq_by_jyl_mc,
            rzrq_jyn_jyl_mc,
            rzrq_sn_jyl_mc,
            rzrq_bn_jyl_mc,
            sz_yj,
            bz_yj,
            sy_yj,
            by_yj,
            jyn_yj,
            sn_yj,
            bn_yj,
            ptzh_sz_yj,
            ptzh_bz_yj,
            ptzh_sy_yj,
            ptzh_by_yj,
            ptzh_jyn_yj,
            ptzh_sn_yj,
            ptzh_bn_yj,
            rzrq_sz_yj,
            rzrq_bz_yj,
            rzrq_sy_yj,
            rzrq_by_yj,
            rzrq_jyn_yj,
            rzrq_sn_yj,
            rzrq_bn_yj,
            sz_yjl,
            bz_yjl,
            sy_yjl,
            by_yjl,
            ptzh_sz_yjl,
            ptzh_bz_yjl,
            ptzh_sy_yjl,
            ptzh_by_yjl,
            ptzh_jyn_yjl,
            rzrq_sz_yjl,
            rzrq_bz_yjl,
            rzrq_sy_yjl,
            rzrq_by_yjl,
            rzrq_jyn_yjl,
            sz_zzl,
            bz_zzl,
            sy_zzl,
            by_zzl,
            jyn_zzl,
            sn_zzl,
            bn_zzl,
            ptzh_sz_zzl,
            ptzh_bz_zzl,
            ptzh_sy_zzl,
            ptzh_by_zzl,
            ptzh_jyn_zzl,
            ptzh_sn_zzl,
            ptzh_bn_zzl,
            rzrq_sz_zzl,
            rzrq_bz_zzl,
            rzrq_sy_zzl,
            rzrq_by_zzl,
            rzrq_jyn_zzl,
            rzrq_sn_zzl,
            rzrq_bn_zzl,
            sz_jycs,
            bz_jycs,
            sy_jycs,
            by_jycs,
            jyn_jycs,
            sn_jycs,
            bn_jycs,
            ptzh_sz_jycs,
            ptzh_bz_jycs,
            ptzh_sy_jycs,
            ptzh_by_jycs,
            ptzh_jyn_jycs,
            ptzh_sn_jycs,
            ptzh_bn_jycs,
            rzrq_sz_jycs,
            rzrq_bz_jycs,
            rzrq_sy_jycs,
            rzrq_by_jycs,
            rzrq_jyn_jycs,
            rzrq_sn_jycs,
            rzrq_bn_jycs,
            ptzh_zjjyrq,
            rzrq_zjjyrq,
            khq,
            khqmc,
            jyy_qczc,
            ptzh_jyy_qczc,
            rzrq_jyy_qczc,
            jyy_jyl,
            ptzh_jyy_jyl,
            rzrq_jyy_jyl,
            jyy_jyl_mr,
            ptzh_jyy_jyl_mr,
            rzrq_jyy_jyl_mr,
            jyy_jyl_mc,
            ptzh_jyy_jyl_mc,
            rzrq_jyy_jyl_mc,
            jyy_yj,
            ptzh_jyy_yj,
            rzrq_jyy_yj,
            jyy_zzl,
            ptzh_jyy_zzl,
            rzrq_jyy_zzl,
            jyy_jycs,
            ptzh_jyy_jycs,
            rzrq_jyy_jycs,
            jbn_jycs,
            ptzh_jbn_jycs,
            rzrq_jbn_jycs,
            jbn_zcjlr,
            ptzh_jbn_zcjlr,
            rzrq_jbn_zcjlr,
            jbn_qczc,
            ptzh_jbn_qczc,
            rzrq_jbn_qczc,
            khjl,
            tzgw,
            fwry,
            ggqq_sz_qlc,
            ggqq_sz_ywc,
            rzrq_rzfz,
            rzrq_rqfz,
            rzrq_lxfz,
            ptzh_djje,
            rzrq_djje,
            ggqq_djje,
            jbn_ykl,
            ptzh_jbn_ykl,
            zzchb,
            jylhb,
            jyjhb,
            bn_jyj,
            by_jyj,
            rzll,
            rqll,
            rzlx,
            rzfx,
            rqfysr,
            rqfx,
            yybzj,
            ljqpcs_jyn,
            jyn_qczc,
            ptzh_jyn_qczc,
            rzrq_jyn_qczc,
            ztzc,
            zqzc,
            sy_rjzc,
            ptzh_sy_rjzc,
            rzrq_sy_rjzc,
            ggqq_sz_ykl,
            ggqq_bz_ykl,
            ggqq_sy_ykl,
            ggqq_by_ykl,
            ggqq_jyy_ykl,
            ggqq_jyn_ykl,
            ggqq_bn_ykl,
            ggqq_sn_ykl,
            jrcp_sz_jyl,
            jrcp_bz_jyl,
            jrcp_sy_jyl,
            jrcp_by_jyl,
            jrcp_jyy_jyl,
            jrcp_jyn_jyl,
            jrcp_sn_jyl,
            jrcp_bn_jyl,
            ggqq_sz_jyl,
            ggqq_bz_jyl,
            ggqq_sy_jyl,
            ggqq_by_jyl,
            ggqq_jyy_jyl,
            ggqq_jyn_jyl,
            ggqq_sn_jyl,
            ggqq_bn_jyl,
            ggqq_bn_jyl_mrkc,
            ggqq_bn_jyl_mrpc,
            ggqq_bn_jyl_mckc,
            ggqq_bn_jyl_mcpc,
            ggqq_sz_yj,
            ggqq_bz_yj,
            ggqq_sy_yj,
            ggqq_by_yj,
            ggqq_jyy_yj,
            ggqq_jyn_yj,
            ggqq_sn_yj,
            ggqq_bn_yj,
            ggqq_bn_jyj,
            ggqq_sz_cjsl,
            ggqq_bz_cjsl,
            ggqq_sy_cjsl,
            ggqq_by_cjsl,
            ggqq_jyy_cjsl,
            ggqq_jyn_cjsl,
            ggqq_bn_cjsl,
            ggqq_sn_cjsl,
            cl1,
            cl2,
            cl3,
            cl4,
            cl5,
            cl6,
            cl7,
            cl8,
            cl9,
            cl10,
            cl11,
            cl12,
            cl13,
            cl14,
            cl15,
            cl16,
            cl17,
            cl18,
            cl19,
            cl20,
            cl21,
            cl22,
            bn_zjjlr,
            ptzh_bn_zjjlr,
            rzrq_bn_zjjlr,
            rjzzc_20r,
            jyn_yjl,
            bn_zgx,
            bn_xc,
            bn_xf,
            otc_bn_yj,
            bn_yjl,
            ptzh_bn_yjl,
            rzrq_bn_yjl,
            sfktlr,
            rqlx,
            by_xc,
            by_xf,
            bn_zczzl,
            ptzh_bn_zczzl,
            rzrq_bn_zczzl,
            jyy_zczzl,
            ptzh_jyy_zczzl,
            rzrq_jyy_zczzl,
            jyy_rjzc,
            ptzh_jyy_rjzc,
            rzrq_jyy_rjzc,
            jrcp_jyy_rjzc,
            ggqq_jyy_rjzc,
            gxlx,
            gxlxmc,
            dqcycpfl,
            cjcycpfl,
            jyy_cjcycpfl,
            jsy_cjcycpfl,
            jbn_cjcycpfl,
            jyn_cjcycpfl,
            fltzc,
            sn_yjl,
            ptzh_sn_yjl,
            rzrq_sn_yjl,
            xldm,
            zydm,
            djje,
            khjb,
            khjbmc,
            xtbq,
            jyy_ykl,
            ptzh_jyy_ykl,
            rzrq_jyy_ykl,
            zfz,
            gmbyl,
            smbyl,
            lcbyl,
            bn_rjjzc,
            ptzh_bn_rjjzc,
            rzrq_bn_rjjzc,
            by_rjjzc,
            ptzh_by_rjjzc,
            rzrq_by_rjjzc,
            jyn_rjjzc,
            ptzh_jyn_rjjzc,
            rzrq_jyn_rjjzc,
            jyy_rjjzc,
            ptzh_jyy_rjjzc,
            rzrq_jyy_rjjzc,
            jsy_zcjlr,
            ptzh_jsy_zcjlr,
            rzrq_jsy_zcjlr,
            ry,
            rymc,
            sz_zgx,
            sy_zgx,
            sn_zgx,
            bz_zgx,
            by_zgx,
            jyy_zgx,
            jbn_zgx,
            jyn_zgx,
            nl,
            xlmc,
            ylqd_short_code,
            ylqd_name,
            bn_fzzc,
            sfktptzh,
            sfktxyzh,
            sfktqqzh,
            zjjyrq,
            tznx,
            level_one,
            level_name_tw,
            level_name_five,
            level_tw,
            level_thr,
            level_four,
            level_five,
            level_name_one,
            level_name_thr,
            level_name_four,
            get_customer_source,
            get_customer_source_name,
            jjtg,
            wbzcgs,
            jszh,
            ptzjzh,
            bmlb,
            bmmc,
            zq,
            zqname,
            xsg
        )
    VALUES
        (
            10000007,
            10000007,
            'i1',
            'ze',
            'ru',
            '99',
            'Yp',
            'O3',
            '6Q',
            'zO',
            'fN',
            'o2',
            'yy',
            'o3',
            45,
            77,
            42,
            72,
            41,
            8031,
            'My',
            31,
            'vT',
            61,
            'Yh',
            41,
            94,
            24,
            53,
            15,
            'NB',
            80,
            'Lr',
            97,
            36,
            'hG',
            89,
            'Ry',
            12,
            '2u',
            87,
            63,
            'z8',
            99,
            'aW',
            86,
            55,
            'nY',
            28,
            'Ky',
            'gB',
            'b8',
            'KU',
            'bu',
            'bi',
            'Tt',
            'cj',
            'XU',
            'Z6',
            '1K',
            'Vc',
            'aH',
            'kH',
            61,
            'vL',
            'by',
            'Fc',
            27,
            'xj',
            7.86,
            95,
            'BG',
            18.80,
            55.62,
            60.29,
            57.93,
            'aw',
            'Xn',
            'hg',
            69.85,
            83.68,
            35.36,
            9.70,
            10.18,
            74.96,
            33.74,
            62.97,
            49.10,
            99.00,
            48.80,
            48.54,
            11.99,
            23.43,
            67.11,
            77.83,
            87.80,
            38.743404,
            36.72994,
            28.74681,
            79.42273,
            42.93,
            29.43,
            55.76,
            15.29,
            61.75,
            75.14,
            88.32,
            84.97,
            81.11,
            56.49,
            9.70,
            14.15,
            4.62,
            65.77,
            7.41,
            86.70,
            15,
            29,
            33,
            15,
            19,
            98,
            67,
            38,
            39,
            63,
            55,
            26,
            68,
            79,
            20,
            42.99,
            66.28,
            23.39,
            87.57,
            28.43,
            1.55,
            13.47,
            61.75,
            72.75,
            52.18,
            63.50,
            79.60,
            25.38,
            1.47,
            19.20,
            39.56,
            3.10,
            90.38,
            13.95,
            56.72,
            42.39,
            1.61,
            83.73,
            21.69,
            85.27,
            64.58,
            16.88,
            71.14,
            78.41,
            41.19,
            14.52,
            37.15,
            6.36,
            33.11,
            2.29,
            4.64,
            43.66,
            43.48,
            80.94,
            16.83,
            65.87,
            39.40,
            57.80,
            27.15,
            48.10,
            29.22,
            58.50,
            0.84,
            77.66,
            44.19,
            20.43,
            23.15,
            42.58,
            31.81,
            42.14,
            86.56,
            6.17,
            18.10,
            11.20,
            20.47,
            73.76,
            86.56,
            38.56,
            32.27,
            86.11,
            45.25,
            74.00,
            21.51,
            88.52,
            33.78,
            60.97,
            82.73,
            19.32,
            59.37,
            4.93,
            69.80,
            22.54,
            4.79,
            9.75,
            19.83,
            7.20,
            50.27,
            49.54,
            27.20,
            50.11,
            33.47,
            75.16,
            87.21,
            68.18,
            12.28,
            77.71,
            79.65,
            29.20,
            60.42,
            47.56,
            4.52,
            13.34,
            21.40,
            51.29,
            88.560210,
            58.322853,
            37.664091,
            43.822809,
            63.817112,
            3.728851,
            9.512347,
            65.477740,
            82.234254,
            70.276274,
            33.321530,
            50.831006,
            38.990150,
            78.336383,
            75.418422,
            5.143038,
            29.575747,
            30.300801,
            49.744628,
            68.114051,
            63.340400,
            25.31,
            68.17,
            31.88,
            8.99,
            59.67,
            23.80,
            45.99,
            6.32,
            82.72,
            24.76,
            58.76,
            50.10,
            79.10,
            87.11,
            45.14,
            33.54,
            8.50,
            21.59,
            87.14,
            25.13,
            21.74,
            68.15,
            79.77,
            9.83,
            64.13,
            44.24,
            64.62,
            54.50,
            8.20,
            79.44,
            15.78,
            88.91,
            19.50,
            79.57,
            75.34,
            32.29,
            20.56,
            77.54,
            76.29,
            48.62,
            53.18,
            32.96,
            82.25,
            89.47,
            87.52,
            0.14,
            0.00,
            35.67,
            29.10,
            9.74,
            62.18,
            35.30,
            62.98,
            79.56,
            88.36,
            26.48,
            74.76,
            49.19,
            69.29,
            27.92,
            7.39,
            59.65,
            59.57,
            84.13,
            70.77,
            6.39,
            21.72,
            68.63,
            31.74,
            82.29,
            88.54,
            81.66,
            80.00,
            62.36,
            77.67,
            4.30,
            4.70,
            2.68,
            28.90,
            24.11,
            50.62,
            20.44,
            2.22,
            44.77,
            26.63,
            70.67,
            53.29,
            28.220575,
            79.203291,
            47.205645,
            21.378081,
            29.926391,
            50.704028,
            87.651866,
            64.869130,
            75.931374,
            44.696606,
            17.553897,
            7.392375,
            76.436932,
            49.768256,
            56.44,
            1.98,
            25.85,
            89.78,
            41.20,
            80.98,
            12.72,
            42.37,
            15.60,
            68.22,
            72.19,
            8.29,
            60.10,
            90.11,
            35.12,
            33.34,
            12.52,
            53.13,
            9.76,
            51.89,
            50.88,
            16.55,
            87.94,
            74.42,
            33.16,
            25.66,
            1.20,
            46.40,
            66.32,
            8.95,
            53.35,
            49.44,
            67.76,
            25.91,
            82.69,
            64.73,
            47.88,
            55.00,
            15.70,
            83.42,
            88.10,
            22.56,
            42,
            44,
            'qj',
            'qN',
            64.16,
            50.80,
            50.28,
            70.94,
            5.79,
            81.87,
            44.65,
            6.10,
            29.55,
            76.89,
            82.87,
            48.50,
            82.37,
            68.81,
            31.75,
            1.20,
            62.78,
            67.48,
            0.15,
            44.42,
            58.15,
            84,
            53,
            27,
            27.66,
            75.78,
            79.24,
            25.57,
            62.78,
            8.96,
            'Fz',
            'Qm',
            'Dn',
            42.53,
            10.44,
            15.56,
            67.15,
            32.92,
            21.22,
            42.94,
            52.30,
            22.474554,
            71.904748,
            37.435,
            76.511,
            67.912,
            81.66,
            1.65,
            53.251350,
            53.907770,
            34.57,
            49.88,
            40.20,
            10.48,
            45.72,
            26,
            22.42,
            88.46,
            62.78,
            29.33,
            68.84,
            66.70,
            15.70,
            13.00,
            80.438743,
            32.559955,
            68.812553,
            75.746583,
            68.115640,
            78.838187,
            52.295686,
            5.523116,
            32.62,
            28.79,
            82.53,
            31.72,
            26.68,
            15.87,
            59.55,
            23.19,
            77.60,
            22.93,
            64.23,
            86.55,
            65.81,
            82.13,
            2.60,
            49.82,
            25.15,
            14.14,
            85.50,
            77.42,
            38.53,
            77.56,
            9.78,
            9.37,
            84.90,
            57.60,
            12.00,
            7.35,
            36.19,
            46.92,
            26.94,
            59.81,
            50.80,
            76.75,
            81.33,
            53.25,
            29.91,
            47,
            88,
            86,
            60,
            98,
            77,
            32,
            88,
            33,
            95,
            59,
            40,
            10,
            77,
            92,
            69,
            95,
            91,
            85,
            88,
            96,
            76,
            23.91,
            49.42,
            44.22,
            56.57,
            38.341389,
            56.86,
            76.36,
            73.13,
            73.41,
            74.735003,
            68.503920,
            74.101693,
            'IG',
            73.95,
            51.27,
            65.20,
            26.24,
            12.94,
            64.16,
            27.63,
            6.89,
            79.12,
            19.64,
            30.88,
            17.52,
            13.27,
            64.90,
            'e2',
            'Ct',
            '0C',
            'XM',
            'cJ',
            'ua',
            '8P',
            'wR',
            36.56,
            3.268491,
            54.974659,
            31.313915,
            'nQ',
            'nD',
            66.71,
            86,
            'PH',
            '3z',
            2.694460,
            34.394338,
            59.221228,
            37.59,
            23.54,
            76.70,
            31.59,
            89.37,
            84.10,
            19.25,
            78.19,
            77.60,
            18.54,
            24.10,
            29.79,
            72.44,
            78.57,
            29.52,
            46.72,
            22.71,
            50.67,
            19.55,
            'cQ',
            'PL',
            70.69,
            37.56,
            74.50,
            43.85,
            46.56,
            29.63,
            44.40,
            85.64,
            22,
            'tp',
            'vj',
            'aM',
            65.75,
            's3',
            'gk',
            'uQ',
            'IH',
            'Ec',
            'ev',
            'Sl',
            'xH',
            'Ij',
            'mq',
            'lP',
            'Gt',
            'Pl',
            'js',
            '3q',
            'Eo',
            'F6',
            13.24,
            17.30,
            'ei',
            'Nz',
            'Or',
            'MT',
            'mV',
            'jM',
            90.79
        ),
        (
            10000007,
            10000007,
            'xt',
            'ox',
            'YF',
            'LQ',
            '9c',
            'D5',
            'RQ',
            's5',
            'bV',
            'PE',
            'pR',
            'gA',
            99,
            95,
            95,
            53,
            88,
            8031,
            'bI',
            23,
            '8W',
            71,
            'tl',
            67,
            93,
            58,
            86,
            96,
            'Rw',
            92,
            'lZ',
            18,
            57,
            'Xy',
            16,
            'XF',
            29,
            'xi',
            72,
            47,
            'sg',
            70,
            'Ju',
            14,
            38,
            'C4',
            62,
            'wN',
            'Hs',
            'z5',
            'y7',
            '3C',
            'jO',
            'Jl',
            'Vu',
            'U4',
            'Mi',
            'K7',
            'HN',
            'UA',
            'oU',
            41,
            'TN',
            'UO',
            'DR',
            29,
            'jY',
            40.80,
            19,
            'tD',
            21.69,
            90.36,
            86.36,
            75.15,
            'RU',
            'Aw',
            '8x',
            60.25,
            38.98,
            56.84,
            66.38,
            38.45,
            35.27,
            28.43,
            77.16,
            42.64,
            101.00,
            14.97,
            57.38,
            55.93,
            12.99,
            48.35,
            36.18,
            86.26,
            11.910252,
            10.18375,
            56.55950,
            0.97285,
            18.26,
            86.74,
            5.77,
            45.11,
            42.41,
            58.32,
            74.80,
            27.77,
            39.78,
            21.34,
            31.32,
            27.88,
            57.52,
            59.96,
            60.65,
            64.12,
            27,
            96,
            91,
            16,
            18,
            94,
            68,
            85,
            38,
            66,
            35,
            74,
            71,
            70,
            99,
            57.85,
            46.35,
            35.54,
            30.12,
            37.22,
            46.52,
            41.31,
            50.44,
            12.93,
            72.39,
            26.33,
            69.80,
            62.20,
            2.40,
            86.86,
            90.42,
            40.40,
            11.44,
            5.20,
            3.21,
            32.60,
            81.90,
            29.71,
            90.58,
            14.60,
            76.20,
            74.98,
            21.24,
            54.54,
            27.88,
            45.75,
            24.93,
            10.94,
            69.88,
            44.45,
            41.64,
            25.98,
            1.10,
            36.53,
            49.28,
            21.64,
            70.70,
            59.29,
            59.79,
            21.59,
            23.69,
            89.71,
            43.67,
            28.18,
            6.60,
            87.58,
            89.75,
            76.32,
            82.78,
            37.38,
            69.25,
            20.55,
            28.19,
            78.23,
            14.83,
            59.40,
            50.00,
            68.21,
            68.25,
            36.66,
            55.82,
            60.41,
            59.34,
            60.56,
            13.60,
            30.30,
            76.27,
            89.45,
            50.96,
            8.22,
            11.96,
            4.23,
            56.94,
            24.15,
            54.12,
            54.57,
            85.38,
            57.52,
            41.62,
            70.87,
            17.93,
            46.59,
            2.71,
            53.89,
            12.53,
            76.00,
            50.81,
            81.35,
            29.26,
            17.70,
            45.45,
            64.75,
            47.42,
            27.46,
            19.449344,
            21.832789,
            11.214982,
            57.762910,
            60.793679,
            52.937933,
            58.670647,
            38.799047,
            39.816889,
            9.924947,
            61.382178,
            22.495820,
            11.448956,
            52.177690,
            68.555788,
            89.947004,
            12.974670,
            38.800771,
            32.480332,
            25.925130,
            6.920880,
            29.52,
            39.54,
            67.17,
            54.13,
            2.92,
            45.78,
            74.95,
            5.91,
            46.50,
            35.79,
            68.20,
            61.66,
            29.75,
            27.39,
            43.83,
            56.47,
            59.95,
            59.99,
            17.29,
            32.83,
            65.35,
            4.32,
            37.57,
            58.00,
            7.79,
            3.58,
            40.63,
            18.30,
            17.45,
            65.99,
            22.00,
            0.82,
            19.80,
            11.90,
            31.56,
            38.11,
            73.80,
            65.73,
            4.53,
            11.23,
            52.50,
            84.60,
            11.00,
            22.63,
            69.58,
            89.24,
            13.13,
            71.47,
            77.91,
            39.53,
            3.57,
            71.17,
            46.89,
            5.76,
            15.73,
            14.40,
            46.52,
            22.90,
            89.71,
            56.24,
            14.85,
            67.70,
            70.70,
            5.77,
            74.89,
            66.84,
            3.59,
            48.30,
            65.20,
            53.45,
            30.83,
            78.91,
            84.20,
            44.64,
            62.19,
            60.10,
            68.68,
            14.62,
            47.70,
            34.80,
            46.80,
            74.80,
            19.00,
            33.50,
            84.22,
            30.67,
            1.46,
            69.324260,
            2.146236,
            8.391278,
            46.190015,
            31.662508,
            34.961556,
            37.552786,
            26.715659,
            26.417926,
            80.273976,
            27.919582,
            79.877255,
            55.621697,
            81.763087,
            0.74,
            34.39,
            61.53,
            46.41,
            60.65,
            8.64,
            42.54,
            87.51,
            27.13,
            70.74,
            29.49,
            47.27,
            19.43,
            43.70,
            1.68,
            82.49,
            17.88,
            62.69,
            21.34,
            8.61,
            50.92,
            35.59,
            37.19,
            75.12,
            62.47,
            86.97,
            67.95,
            44.73,
            48.10,
            86.80,
            31.47,
            53.65,
            75.79,
            3.54,
            88.14,
            13.90,
            2.85,
            52.38,
            59.50,
            29.20,
            56.17,
            33.10,
            84,
            58,
            '1u',
            '2C',
            46.54,
            45.69,
            38.18,
            6.78,
            49.65,
            80.20,
            34.50,
            61.71,
            41.14,
            15.74,
            49.70,
            90.68,
            33.64,
            69.24,
            65.88,
            13.90,
            17.88,
            53.30,
            17.47,
            67.93,
            48.81,
            40,
            46,
            76,
            34.50,
            52.55,
            82.36,
            21.74,
            25.94,
            79.10,
            'Gi',
            'M8',
            'CS',
            12.26,
            44.10,
            81.96,
            14.33,
            61.26,
            61.80,
            29.40,
            20.57,
            12.144110,
            8.398718,
            71.308,
            15.554,
            29.311,
            46.56,
            6.33,
            3.870077,
            45.832327,
            12.39,
            4.35,
            28.85,
            14.92,
            88.60,
            84,
            0.17,
            11.56,
            22.54,
            16.50,
            56.35,
            72.00,
            85.18,
            32.50,
            22.275797,
            54.240888,
            58.609557,
            50.742840,
            77.902665,
            32.328138,
            9.738135,
            37.566328,
            60.54,
            62.23,
            19.88,
            9.61,
            20.70,
            20.77,
            57.25,
            5.96,
            41.65,
            81.61,
            30.98,
            27.32,
            0.00,
            26.89,
            44.88,
            21.79,
            9.71,
            55.50,
            69.97,
            49.60,
            62.42,
            26.35,
            20.90,
            86.70,
            90.66,
            46.46,
            60.18,
            10.75,
            45.12,
            14.23,
            83.29,
            1.55,
            64.34,
            27.57,
            33.47,
            59.84,
            3.73,
            28,
            86,
            92,
            93,
            52,
            69,
            21,
            66,
            49,
            69,
            75,
            96,
            94,
            100,
            70,
            68,
            68,
            69,
            84,
            89,
            57,
            36,
            78.32,
            81.21,
            9.57,
            43.66,
            59.617879,
            80.60,
            20.00,
            22.64,
            31.96,
            43.553521,
            47.138657,
            4.176060,
            'Nf',
            88.51,
            28.15,
            77.32,
            15.98,
            65.88,
            63.94,
            52.78,
            36.85,
            51.96,
            87.53,
            35.30,
            66.51,
            1.86,
            5.15,
            'zQ',
            'xc',
            'E8',
            'HH',
            'EN',
            'vC',
            'PX',
            '95',
            15.21,
            26.115630,
            84.105200,
            69.348403,
            'BI',
            'zI',
            88.51,
            85,
            'lF',
            'aH',
            68.328683,
            76.850540,
            5.528574,
            79.73,
            67.00,
            24.97,
            54.40,
            7.34,
            13.79,
            41.10,
            84.90,
            45.63,
            15.62,
            24.88,
            86.11,
            35.97,
            88.93,
            39.48,
            18.68,
            47.40,
            5.54,
            87.33,
            'MM',
            'W4',
            31.70,
            12.70,
            82.98,
            82.50,
            16.71,
            15.11,
            37.75,
            86.00,
            79,
            'ib',
            'mf',
            '0c',
            72.22,
            'sf',
            'MP',
            'dQ',
            'M4',
            'Fw',
            'IA',
            'MO',
            'mS',
            '2Y',
            'RG',
            'LM',
            'su',
            '9R',
            'tQ',
            'iL',
            'Ae',
            'MQ',
            4.46,
            15.46,
            'J3',
            'uB',
            'sl',
            'RY',
            'yh',
            'ji',
            69.34
        ),
        (
            10000007,
            10000007,
            'VA',
            '40',
            '43',
            '9y',
            'b0',
            'dy',
            'gq',
            'Ij',
            'F4',
            '5V',
            'iy',
            'es',
            66,
            74,
            40,
            19,
            48,
            8031,
            'Eo',
            67,
            'zQ',
            73,
            'Gp',
            59,
            39,
            37,
            85,
            35,
            'Xt',
            23,
            'p3',
            64,
            43,
            '1Q',
            30,
            'jb',
            63,
            'y5',
            83,
            90,
            '49',
            19,
            'Xm',
            87,
            44,
            'oW',
            11,
            'Cq',
            'pD',
            'wV',
            'n4',
            'uN',
            'lX',
            'Hx',
            '6s',
            'TF',
            'ZF',
            'WY',
            'uV',
            '9U',
            'jd',
            60,
            'Z6',
            '86',
            'hR',
            100,
            'Px',
            66.33,
            36,
            'wR',
            55.62,
            26.79,
            26.10,
            56.79,
            'hV',
            'dN',
            'Wm',
            29.91,
            84.25,
            84.20,
            16.28,
            59.00,
            47.75,
            87.93,
            28.15,
            78.60,
            100.00,
            70.90,
            4.30,
            5.80,
            4.57,
            8.52,
            56.97,
            71.72,
            61.530739,
            50.35009,
            11.21757,
            34.74684,
            69.23,
            84.32,
            4.49,
            13.62,
            9.34,
            57.84,
            1.40,
            86.19,
            80.54,
            61.69,
            54.58,
            39.40,
            66.74,
            23.49,
            81.12,
            41.50,
            83,
            66,
            91,
            24,
            52,
            18,
            59,
            75,
            88,
            44,
            91,
            89,
            89,
            43,
            77,
            70.35,
            37.72,
            74.11,
            52.57,
            33.25,
            68.95,
            89.43,
            11.47,
            22.27,
            12.44,
            5.54,
            85.52,
            10.21,
            70.75,
            14.77,
            31.00,
            43.19,
            74.70,
            47.95,
            42.13,
            59.89,
            16.96,
            47.11,
            29.93,
            62.46,
            27.15,
            43.76,
            53.23,
            24.84,
            29.49,
            41.53,
            71.30,
            49.00,
            44.72,
            41.51,
            15.50,
            75.25,
            86.88,
            20.92,
            40.73,
            61.21,
            10.75,
            86.72,
            9.92,
            38.80,
            83.38,
            10.90,
            63.13,
            79.67,
            41.22,
            75.72,
            60.65,
            15.41,
            63.68,
            50.81,
            90.87,
            59.63,
            7.20,
            79.33,
            65.71,
            63.11,
            55.70,
            18.71,
            1.79,
            41.52,
            35.50,
            55.22,
            88.21,
            38.25,
            24.64,
            70.10,
            58.40,
            45.27,
            74.29,
            40.83,
            26.34,
            53.52,
            32.27,
            73.91,
            90.81,
            82.83,
            42.71,
            87.74,
            62.40,
            62.40,
            70.10,
            56.45,
            80.21,
            54.20,
            66.10,
            76.27,
            72.88,
            46.80,
            54.35,
            44.88,
            88.60,
            9.13,
            44.62,
            53.63,
            12.606823,
            31.239831,
            6.159336,
            49.384105,
            31.679608,
            56.713094,
            61.385919,
            64.286729,
            58.238584,
            86.661107,
            12.849681,
            4.627707,
            9.438265,
            89.164620,
            12.120401,
            61.612412,
            75.525182,
            41.940972,
            38.903800,
            30.993664,
            12.443632,
            7.84,
            90.38,
            2.17,
            32.24,
            35.80,
            31.99,
            89.50,
            55.87,
            40.20,
            63.68,
            74.61,
            77.12,
            86.64,
            20.47,
            9.10,
            15.58,
            47.63,
            46.81,
            18.25,
            76.98,
            57.00,
            45.45,
            83.47,
            72.80,
            38.36,
            53.31,
            1.26,
            36.44,
            1.98,
            84.82,
            9.12,
            56.61,
            87.30,
            72.20,
            84.89,
            63.40,
            88.35,
            66.45,
            6.81,
            63.62,
            80.79,
            41.17,
            57.35,
            47.91,
            76.51,
            19.27,
            50.83,
            83.58,
            36.33,
            53.42,
            8.55,
            33.71,
            32.69,
            21.90,
            37.45,
            82.67,
            2.83,
            85.80,
            17.77,
            1.85,
            0.88,
            10.53,
            22.14,
            3.60,
            21.59,
            26.47,
            16.60,
            55.86,
            22.33,
            11.19,
            49.74,
            54.55,
            59.95,
            14.96,
            5.64,
            7.27,
            63.75,
            30.55,
            88.94,
            68.86,
            50.59,
            37.21,
            86.48,
            7.29,
            1.70,
            55.48,
            17.39,
            11.816207,
            7.588556,
            63.951446,
            50.683043,
            74.964118,
            28.605967,
            9.917708,
            88.755000,
            55.379528,
            6.491721,
            73.725170,
            47.361100,
            38.355305,
            40.408715,
            17.56,
            53.96,
            30.63,
            62.52,
            77.50,
            80.44,
            64.10,
            45.39,
            79.50,
            54.47,
            66.92,
            38.30,
            3.40,
            55.86,
            29.58,
            11.93,
            63.21,
            0.66,
            50.13,
            5.38,
            31.30,
            72.17,
            11.95,
            0.54,
            90.14,
            6.73,
            78.90,
            82.14,
            9.55,
            55.41,
            49.27,
            34.13,
            4.59,
            63.40,
            77.30,
            71.91,
            11.93,
            63.52,
            52.80,
            3.17,
            20.60,
            80.83,
            97,
            30,
            'XC',
            'uh',
            16.94,
            0.60,
            29.93,
            24.97,
            38.60,
            89.40,
            8.95,
            25.35,
            44.20,
            5.35,
            10.86,
            84.46,
            41.39,
            21.39,
            59.72,
            42.57,
            39.93,
            61.72,
            56.68,
            34.60,
            8.16,
            57,
            56,
            67,
            82.19,
            55.88,
            74.81,
            45.22,
            52.43,
            28.25,
            '4P',
            'ol',
            '8e',
            19.29,
            46.15,
            89.57,
            33.70,
            33.94,
            7.34,
            13.10,
            75.12,
            80.175957,
            77.218460,
            38.631,
            79.603,
            59.630,
            26.86,
            17.74,
            85.580189,
            46.331504,
            71.77,
            28.60,
            22.10,
            8.12,
            87.78,
            77,
            63.99,
            17.87,
            14.51,
            56.82,
            76.59,
            10.53,
            56.96,
            14.88,
            10.686673,
            57.291460,
            50.375523,
            68.997174,
            56.762140,
            83.941676,
            28.105420,
            52.483476,
            86.58,
            45.26,
            13.85,
            26.28,
            59.65,
            23.69,
            10.29,
            23.97,
            46.13,
            77.42,
            26.20,
            52.37,
            40.50,
            29.58,
            48.81,
            37.69,
            69.20,
            14.87,
            7.16,
            6.17,
            29.59,
            70.40,
            68.44,
            5.97,
            38.57,
            34.50,
            57.22,
            67.20,
            40.10,
            20.63,
            89.80,
            32.20,
            24.62,
            75.00,
            57.60,
            6.69,
            59.25,
            50,
            62,
            87,
            32,
            84,
            77,
            70,
            76,
            60,
            75,
            18,
            82,
            75,
            39,
            48,
            97,
            19,
            39,
            93,
            69,
            52,
            85,
            32.25,
            41.13,
            0.17,
            44.42,
            22.247195,
            6.97,
            4.63,
            35.80,
            90.16,
            9.514569,
            78.792163,
            29.544784,
            'y3',
            43.40,
            54.98,
            31.12,
            78.64,
            41.27,
            3.46,
            17.47,
            5.86,
            80.18,
            87.54,
            22.63,
            73.51,
            48.55,
            32.73,
            'Dv',
            'sR',
            'mD',
            'ml',
            'dX',
            'FU',
            'Sk',
            'yA',
            20.32,
            15.684845,
            76.970753,
            50.236843,
            '5V',
            'XO',
            12.46,
            51,
            'V9',
            'WC',
            27.154478,
            47.996990,
            71.882292,
            27.42,
            21.81,
            84.90,
            51.32,
            32.64,
            90.39,
            38.82,
            13.35,
            27.61,
            64.54,
            33.82,
            23.46,
            79.52,
            10.70,
            27.29,
            48.52,
            20.60,
            21.80,
            47.24,
            'rc',
            'pO',
            28.22,
            42.34,
            12.10,
            35.37,
            34.12,
            11.39,
            77.96,
            22.79,
            32,
            'W7',
            '5c',
            'iI',
            12.30,
            'M0',
            'hg',
            '0N',
            '4Q',
            'uy',
            'Fp',
            'qB',
            'tE',
            'sh',
            '9H',
            'Z9',
            'it',
            '5M',
            '37',
            'Dm',
            'NB',
            'bg',
            20.83,
            44.81,
            'yd',
            'CT',
            'Qs',
            'Kw',
            'ex',
            'M2',
            11.26
        );
    
    INSERT INTO
        USR_TLBL_VAL_R (
            lbl_id,
            khh,
            lbl_clss_id,
            lbl_clss_nm,
            lbl_type_id,
            lbl_type_name,
            lbl_nm,
            lbl_val_id,
            lbl_val_code,
            lbl_val_name,
            lbl_val_dsc,
            jsrq
        )
    VALUES
        (
            60426,
            10000007,
            63,
            'nn',
            53,
            'ER',
            'Kw',
            29,
            'qP',
            'NO',
            'vp',
            78
        ),
        (
            94460,
            10000007,
            69,
            'yi',
            94,
            'Q7',
            'XX',
            62,
            'jB',
            'Ff',
            'lz',
            46
        ),
        (
            48414,
            10000007,
            92,
            'hV',
            78,
            'cl',
            'nn',
            94,
            'Vg',
            'DZ',
            'MD',
            94
        );
    
        set parallel_pipeline_task_num=17;
        set enable_sql_cache=false;
        set enable_nereids_distribute_planner=true;"""

    test {
        sql "select cast(sum(zzc) as int) from USR_V_KHZHSJ_ES_POC A,USR_TLBL_VAL_R B WHERE A.khid = B.khh AND A.zzc >100 AND B.lbl_id IN (94460,48414,60426) limit 100"
        result([[303]])
    }
}
